/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.helwen.restaurantbooking.datalayer.dao;

import com.helwen.restaurantbooking.datalayer.entities.TblBooking;
import java.util.Collection;
import java.util.Date;
import java.util.List;

/**
 *
 * @author Nghiata
 */
public interface IBookingDao {

    List<TblBooking> getAllBookingInfo();

    List<TblBooking> getBookingByCriteria(String searchName, String searchContact);

    void saveOrUpdate(TblBooking tblBooking);

    TblBooking getBookingById(Integer id);

    List<TblBooking> getBookingByNumberDateTime(Integer number, Date date, Short time);

    List<TblBooking> getWaitingBooking();

    void deleteAll();

    void bulkInsert(Collection<TblBooking> tblBookings);
    List<TblBooking> getAllBookingInfoOrderby(String columnName,String sort);
    List<TblBooking> getBookingByCriteriaOrderBy(String searchName, String searchContact, String columnName, String sort);
}
